Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# AGGROPS

The AGGROPS function returns the keywords for all of the aggregation operators that you can specify in a RELATION (for aggregation) statement, listed one name on each line in a multiline text value.

Return Value

`TEXT`

Syntax

AGGROPS

Example

Example 7-14 Displaying a List of the Aggregation Operators

When you issue a a AGGROPS statement, Oracle OLAP returns a list of all of the aggregation operators.

    SHOW AGGROPS

    SUM
    WSUM
    SSUM
    AND
    OR
    FIRST
    LAST
    HFIRST
    HLAST
    AVERAGE
    WAVERAGE
    HAVERAGE
    HWAVERAGE
    MIN
    MAX
    WFIRST
    WLAST
    HWFIRST
    HWLAST
    WMIN
    WMAX
    NOAGG